package com.ruoyi.web.controller.system;

import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.List;
import java.util.stream.Collectors;

import com.ruoyi.system.domain.int_0105_djglzxxb_sg;
import jakarta.servlet.http.HttpServletResponse;
import org.apache.commons.lang3.ArrayUtils;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.domain.entity.SysDept;
import com.ruoyi.common.core.domain.entity.SysRole;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.system.service.ISysDeptService;
import com.ruoyi.system.service.ISysPostService;
import com.ruoyi.system.service.ISysRoleService;
import com.ruoyi.system.service.ISysUserService;

/**
 * 用户信息
 *
 * @author ruoyi
 */
@RestController
@RequestMapping("/system/user")
public class SysUserController extends BaseController
{
    @Autowired
    private ISysUserService userService;

    @Autowired
    private ISysRoleService roleService;

    @Autowired
    private ISysDeptService deptService;

    @Autowired
    private ISysPostService postService;

    /**
     * 获取用户列表
     */
    @PreAuthorize("@ss.hasPermi('system:user:list')")
    @GetMapping("/list")
    public TableDataInfo list(SysUser user)
    {
        startPage();
        List<SysUser> list = userService.selectUserList(user);
        return getDataTable(list);
    }

    @Log(title = "用户管理", businessType = BusinessType.EXPORT)
    @PreAuthorize("@ss.hasPermi('system:user:export')")
    @PostMapping("/export")
    public void export(HttpServletResponse response, SysUser user)
    {
        List<SysUser> list = userService.selectUserList(user);
        ExcelUtil<SysUser> util = new ExcelUtil<SysUser>(SysUser.class);
        util.exportExcel(response, list, "用户数据");
    }

    @Log(title = "用户管理", businessType = BusinessType.IMPORT)
    @PreAuthorize("@ss.hasPermi('system:user:import')")
    @PostMapping("/importData")
    public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception
    {
        System.out.println("董监高履。。。：");
        ExcelUtil<int_0105_djglzxxb_sg> util1 = new ExcelUtil<int_0105_djglzxxb_sg>(int_0105_djglzxxb_sg.class);
        List<int_0105_djglzxxb_sg> userList1 = util1.importExcelShouGongCaiji(file.getInputStream());
        String operName1 = getUsername();
        System.out.println("userList1---");
        System.out.println(userList1);

        System.out.println("ddfdfd");


        ExcelUtil<SysUser> util = new ExcelUtil<SysUser>(SysUser.class);
        List<SysUser> userList = util.importExcel(file.getInputStream());

        System.out.println("读取到的数据");
        System.out.println(userList);
        String operName = getUsername();
      //  String message = userService.importUser(userList, updateSupport, operName);
        return success("message");
    }

//    @PostMapping("downloadExcel")
//    @RmpLog(value = "三低预警细项分数导出", type = "6")
    public void downExcel( HttpServletResponse response) throws IOException {

        File file = new File(  "d:/down_org_score.xlsx"); //导出模板
        InputStream is;
        XSSFWorkbook wb = null;
        XSSFSheet sheet = null;
        if (file.exists()) {
            //将file 转换成MultipartFile
//            try {
//                MultipartFile mf = new MockMultipartFile(file.getName(), new FileInputStream(file));
//                is = mf.getInputStream();
//                //获取文件名
//                //String fileName = mf.getOriginalFilename(); 获取原始文件名。在单元测试中值是空的。可能不是通过页面上传获取到的文件。
//                String fileName = mf.getName();
//                if (fileName.endsWith("xls")) {
//                    // wb = new HSSFWorkbook(is);
//                } else if (fileName.endsWith("xlsx")) {
//                    wb = new XSSFWorkbook(is);
//                }
//            } catch (Exception e) {
//                e.printStackTrace();
//            }
//            sheet = wb.getSheetAt(0);

        } else {
            wb = new XSSFWorkbook();
            sheet = wb.createSheet("机构评估结果");
            Row titleRow = sheet.createRow(0);
            String[] titles = {"评估日期", "评估频率", "机构层级", "机构名称", "得分(百分制)", "排名", "排名变化", "评分等级"};

            for (int i = 0; i < titles.length; i++) {
                titleRow.createCell(i).setCellValue(titles[i]);
            }
        }

//        if (lists != null && lists.size() > 0) {
//            java.awt.Color coloup = new java.awt.Color(65, 255, 64);
//            XSSFColor xssfColorUp = new XSSFColor(coloup, new DefaultIndexedColorMap());
//
//            java.awt.Color colodown = new java.awt.Color(250, 62, 64);
//
//            XSSFColor xssfColorDown = new XSSFColor(colodown, new DefaultIndexedColorMap());
//
//            CellStyle cellStyle = wb.createCellStyle();
//            cellStyle.setAlignment(HorizontalAlignment.CENTER);//水平居中
//
//            for (int i = 0; i < lists.size(); i++) {
//                XSSFRow row = sheet.createRow(i + 2);
//                //Row row = sheet.createRow(i + 1);
//                DownTotalScoreList item = lists.get(i);
//                String taccessTime = item.getTaccessTime();
//
//                if (item.getCscoreFreqCode().equals("3")) {
//                    taccessTime = taccessTime.substring(0, 4) + "Q" + taccessTime.substring(5, 6);
//                } else {
//                    taccessTime = taccessTime.substring(0, 4) + "M" + taccessTime.substring(4, 6);
//                }
//
//
//                filledRow(row, 1, taccessTime);
//                String freqName = "";
//                switch (item.getCscoreFreqCode()) {
//                    case "1":
//                        freqName = "月度";
//                        break;
//                    case "2":
//                        freqName = "年度";
//                        break;
//                    case "3":
//                        freqName = "季度";
//                }
//
//                filledRow(row, 2, freqName);
//
//                String levelName = item.getCorgLevelCode();
//                if (StringUtils.isNotBlank(item.getCorgLevelCode())) {
//                    if ("1".equals(item.getCorgLevelCode())) {
//                        levelName = "总公司";
//                    }
//                    if ("2".equals(item.getCorgLevelCode())) {
//                        levelName = "省级分公司";
//                    }
//                    if ("3".equals(item.getCorgLevelCode())) {
//                        levelName = "地市分公司";
//                    }
//                    if ("4".equals(item.getCorgLevelCode())) {
//                        levelName = "县支分公司";
//                    }
//                }
//
//                filledRow(row, 3, levelName);
//                filledRow(row, 4, item.getCorganName());
//
//
//                item.setCscoreValue(getFormatScoreValue(item.getCscoreValue()));
//
//                filledRow(row, 5, item.getCscoreValue());
//                filledRow(row, 6, item.getCorganRank());
//
//
//                String cchainRate = item.getCchainRate();
//
//                Double chainInt = 0d;
//                String chainStr = "";
//                if (StringUtils.isNotBlank(cchainRate)) {
//                    chainInt = Double.parseDouble(cchainRate);
//                    chainStr = new Double(chainInt).intValue() + "";
//                }
//
//
//                if (chainInt > 0) {
//                    cchainRate = "↑" + chainStr;
//                    XSSFFont font = wb.createFont();
//
//                    font.setColor(xssfColorUp); //红色
//                    font.setBold(true); //是否加粗
//                    XSSFRichTextString ts = new XSSFRichTextString(cchainRate);
//                    ts.applyFont(0, cchainRate.length(), font); //0起始索引,2结束索引    标题长度
//                    row.createCell(7).setCellValue(ts); //i为第几列，row为第几行
//
//                } else if (chainInt == 0) {
//                    cchainRate = "-";
//                    row.createCell(7).setCellValue(cchainRate);
//                } else {
//                    cchainRate = "↓" + chainStr;
//                    cchainRate = cchainRate.replace("-", "");
//                    XSSFFont font = wb.createFont();
//                    font.setColor(xssfColorDown);
//                    font.setBold(true); //是否加粗
//                    XSSFRichTextString ts = new XSSFRichTextString(cchainRate);
//                    ts.applyFont(0, cchainRate.length(), font); //0起始索引,2结束索引    标题长度
//                    row.createCell(7).setCellValue(ts); //i为第几列，row为第几行
//
//                }
//
//
//                filledRow(row, 8, item.getCscoreGrade());
//                for (int j = 1; j <= 8; j++) {
//                    row.getCell(j).setCellStyle(cellStyle);
//                }
//            }
//        }
        String fileName = "数据测试";
        //===将生成的Excel以流输出====
        OutputStream ouputStream = response.getOutputStream();
        //String fileName = "导出错误";
        fileName = URLEncoder.encode(fileName, "UTF-8");
        response.reset();
        response.setContentType("application/vnd.ms-excel");
        response.setHeader("Content-Disposition", "attachment;filename=hello.xlsx");
        wb.write(ouputStream);
        ouputStream.flush();
        ouputStream.close();

    }



    @PostMapping("/importTemplate")
    public void importTemplate(HttpServletResponse response)
    {
        ExcelUtil<SysUser> util = new ExcelUtil<SysUser>(SysUser.class);
        util.importTemplateExcel(response, "用户数据");
    }

    /**
     * 根据用户编号获取详细信息
     */
    @PreAuthorize("@ss.hasPermi('system:user:query')")
    @GetMapping(value = { "/", "/{userId}" })
    public AjaxResult getInfo(@PathVariable(value = "userId", required = false) Long userId)
    {
        AjaxResult ajax = AjaxResult.success();
        if (StringUtils.isNotNull(userId))
        {
            userService.checkUserDataScope(userId);
            SysUser sysUser = userService.selectUserById(userId);
            ajax.put(AjaxResult.DATA_TAG, sysUser);
            ajax.put("postIds", postService.selectPostListByUserId(userId));
            ajax.put("roleIds", sysUser.getRoles().stream().map(SysRole::getRoleId).collect(Collectors.toList()));
        }
        List<SysRole> roles = roleService.selectRoleAll();
        ajax.put("roles", SysUser.isAdmin(userId) ? roles : roles.stream().filter(r -> !r.isAdmin()).collect(Collectors.toList()));
        ajax.put("posts", postService.selectPostAll());
        return ajax;
    }

    /**
     * 新增用户
     */
    @PreAuthorize("@ss.hasPermi('system:user:add')")
    @Log(title = "用户管理", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@Validated @RequestBody SysUser user)
    {
        deptService.checkDeptDataScope(user.getDeptId());
        roleService.checkRoleDataScope(user.getRoleIds());
        if (!userService.checkUserNameUnique(user))
        {
            return error("新增用户'" + user.getUserName() + "'失败，登录账号已存在");
        }
        else if (StringUtils.isNotEmpty(user.getPhonenumber()) && !userService.checkPhoneUnique(user))
        {
            return error("新增用户'" + user.getUserName() + "'失败，手机号码已存在");
        }
        else if (StringUtils.isNotEmpty(user.getEmail()) && !userService.checkEmailUnique(user))
        {
            return error("新增用户'" + user.getUserName() + "'失败，邮箱账号已存在");
        }
        user.setCreateBy(getUsername());
        user.setPassword(SecurityUtils.encryptPassword(user.getPassword()));
        return toAjax(userService.insertUser(user));
    }

    /**
     * 修改用户
     */
    @PreAuthorize("@ss.hasPermi('system:user:edit')")
    @Log(title = "用户管理", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@Validated @RequestBody SysUser user)
    {
        userService.checkUserAllowed(user);
        userService.checkUserDataScope(user.getUserId());
        deptService.checkDeptDataScope(user.getDeptId());
        roleService.checkRoleDataScope(user.getRoleIds());
        if (!userService.checkUserNameUnique(user))
        {
            return error("修改用户'" + user.getUserName() + "'失败，登录账号已存在");
        }
        else if (StringUtils.isNotEmpty(user.getPhonenumber()) && !userService.checkPhoneUnique(user))
        {
            return error("修改用户'" + user.getUserName() + "'失败，手机号码已存在");
        }
        else if (StringUtils.isNotEmpty(user.getEmail()) && !userService.checkEmailUnique(user))
        {
            return error("修改用户'" + user.getUserName() + "'失败，邮箱账号已存在");
        }
        user.setUpdateBy(getUsername());
        return toAjax(userService.updateUser(user));
    }

    /**
     * 删除用户
     */
    @PreAuthorize("@ss.hasPermi('system:user:remove')")
    @Log(title = "用户管理", businessType = BusinessType.DELETE)
    @DeleteMapping("/{userIds}")
    public AjaxResult remove(@PathVariable Long[] userIds)
    {
        if (ArrayUtils.contains(userIds, getUserId()))
        {
            return error("当前用户不能删除");
        }
        return toAjax(userService.deleteUserByIds(userIds));
    }

    /**
     * 重置密码
     */
    @PreAuthorize("@ss.hasPermi('system:user:resetPwd')")
    @Log(title = "用户管理", businessType = BusinessType.UPDATE)
    @PutMapping("/resetPwd")
    public AjaxResult resetPwd(@RequestBody SysUser user)
    {
        userService.checkUserAllowed(user);
        userService.checkUserDataScope(user.getUserId());
        user.setPassword(SecurityUtils.encryptPassword(user.getPassword()));
        user.setUpdateBy(getUsername());
        return toAjax(userService.resetPwd(user));
    }

    /**
     * 状态修改
     */
    @PreAuthorize("@ss.hasPermi('system:user:edit')")
    @Log(title = "用户管理", businessType = BusinessType.UPDATE)
    @PutMapping("/changeStatus")
    public AjaxResult changeStatus(@RequestBody SysUser user)
    {
        userService.checkUserAllowed(user);
        userService.checkUserDataScope(user.getUserId());
        user.setUpdateBy(getUsername());
        return toAjax(userService.updateUserStatus(user));
    }

    /**
     * 根据用户编号获取授权角色
     */
    @PreAuthorize("@ss.hasPermi('system:user:query')")
    @GetMapping("/authRole/{userId}")
    public AjaxResult authRole(@PathVariable("userId") Long userId)
    {
        AjaxResult ajax = AjaxResult.success();
        SysUser user = userService.selectUserById(userId);
        List<SysRole> roles = roleService.selectRolesByUserId(userId);
        ajax.put("user", user);
        ajax.put("roles", SysUser.isAdmin(userId) ? roles : roles.stream().filter(r -> !r.isAdmin()).collect(Collectors.toList()));
        return ajax;
    }

    /**
     * 用户授权角色
     */
    @PreAuthorize("@ss.hasPermi('system:user:edit')")
    @Log(title = "用户管理", businessType = BusinessType.GRANT)
    @PutMapping("/authRole")
    public AjaxResult insertAuthRole(Long userId, Long[] roleIds)
    {
        userService.checkUserDataScope(userId);
        roleService.checkRoleDataScope(roleIds);
        userService.insertUserAuth(userId, roleIds);
        return success();
    }

    /**
     * 获取部门树列表
     */
    @PreAuthorize("@ss.hasPermi('system:user:list')")
    @GetMapping("/deptTree")
    public AjaxResult deptTree(SysDept dept)
    {
        return success(deptService.selectDeptTreeList(dept));
    }
}
